1] Add days directly If the expiry period is defined in days, you can calculate the expiry date by simply adding the number of days to the starting date using the + operator. For example, if cell ...

Learn to create a zero-click Excel workflow with automation tools like Office Scripts and Power Automate. Save time and reduce errors today.

There, you'll see the various date formatting options you can select to force Excel to see your value as a date.