VBA dates from one sheet to next

[SarahNoob]

Hello

I have sheet1 with a range of dates. These dates are either today or a period before today.

I am trying (unsuccessfully) to print these dates into sheet2.

I need to offset any date that is today by 1 day but if the date is before today leave it as is.

Thank you for your time.

S

 

[Mr_Kay]

Hi there SarahNoob,

You can reference a cell from another sheet by appending the sheet name in front of the cell reference and adding an ! (example: =Sheet1!D4)
To check if a date is today, you can use the TODAY() function in an IF statement.
To offset a date, you can reference the cell with the date and simply add/subtract 1.
You'll need to make sure the cell is formatted as a date, or you may get some undesired results.
To format a cell as a date, navigate to Home --> Number and select Short Date from the drop down box.

Proving Grounds.xlsx
	A	B
1	Date	Offset date
2	3/15/2025	3/15/2025
3	3/16/2025	3/16/2025
4	3/17/2025	3/17/2025
5	3/18/2025	3/18/2025
6	3/19/2025	3/20/2025
Date Offset

Cell Formulas
Range	Formula
B2:B6	B2	=IF(A2=TODAY(), A2+1, A2)

Hope this helps :D