Thread
: [Solved]
Request for help with a formula
View Single Post
08-08-2020, 08:13 AM
Purfleet
Windows 10
Office 2019
Expert
Join Date: Jun 2020
Location: Essex
Posts: 345
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
SAMPLE_purfleet.xlsx
(11.3 KB, 5 views)
Purfleet
View Public Profile
Find all posts by Purfleet