web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Add month into Date

(0) ShareShare
ReportReport
Posted on by 34
Hi, 
 

I have a question, how can I add 6 months or 1 year to today instead of days.

I only have this formula but I don't want days but months inside it.

Example: Today + 6 months 

 
formatDateTime(addDays(utcNow(), +183), 'yyyy-MM-dd')
Categories:
  • RezaDorrani Profile Picture
    12,145 on at

    Hi @SOL24 

     

    There is no addmonths function.

    https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#date-and-time-functions

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

  • SOL24 Profile Picture
    34 on at

    Can I multiply 30 * 12? to get 1 year? likewise for 6 months?

  • Verified answer
    RezaDorrani Profile Picture
    12,145 on at

    Hi @SOL24 ,

     

    Yes use mul(12,30)

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

  • SOL24 Profile Picture
    34 on at
    Like this:
     
    formatDateTime(addDays(utcNow(), mul(12,30)), 'yyyy-MM-dd')
     
    Thanks for your help 🙂
  • RezaDorrani Profile Picture
    12,145 on at

    Yes 🙂

  • ronn_zw Profile Picture
    26 on at

    Hi @SOL24 
    This one worked for me just fine. To get a previous date use minus, so in the example below 6 would be -6. utcNow() returns today's date so replace that with your actual date.

     

    addToTime(utcNow(),6,'Month','yyyy-MM-dd')

  • carterbarry88 Profile Picture
    64 on at

    Hi there,

     

    There is a way to add a specific number of months to a date using the "Add to time" action.

     

    carterbarry88_0-1716896448218.png

     

    carterbarry88_1-1716896471270.png

    Hope this helps someone

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 308 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 159

Last 30 days Overall leaderboard