Thread: [Solved] Request for help with a formula
View Single Post
 
Old 08-08-2020, 08:13 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
If you are keeping the row number in you spreadsheet you can make the formula a bit easier and then wrap it in Datevalue to get a proper date


=DATEVALUE(DAY(INDEX(B:B,H3,0))&INDEX(A:A,H3,0)&YE AR(TODAY()))
Attached Files
File Type: xlsx SAMPLE_purfleet.xlsx (11.3 KB, 5 views)
Reply With Quote