Auto populating due date based on a frequency with frequency dropdown

T

thunder12nov2006

New Member
Joined
Jan 12, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I need to make a yearly calendar for maintenance based on frequency in a dropdown, Daily, Weekly, Monthly, Semi-annually, Annually, Bi-annually. example if my dropdown is daily the calendar is marked on everyday but if i change it to weekly the calendar changes its marks based on the frequency. i cannot figure this out. please help.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
You must log in or register to reply here.

Similar threads

M
  • Solved
Auto update the date range
Replies
3
Views
248
kvsrinivasamurthy
K
B
  • Question Question
color tabs for multiple dates
Replies
5
Views
373
6StringJazzer
6StringJazzer
I
  • Question Question
Accrual Worksheet Next Pay date Formula
Replies
0
Views
287
ItalianPlatinum
I
Juddman79
  • Solved
Testing schedule based on frequency and date
Replies
3
Views
653
felixstraube
F
C
  • Question Question
Calculate Remaining Paychecks Before Year End
Replies
3
Views
2K
JamesCanale
JamesCanale

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top